|
An OLAP cube is a term that typical refers to multi-dimensional array of data. ''OLAP'' is an acronym for online analytical processing, 〔(【引用サイトリンク】title=Just What Are Cubes Anyway? (A Painless Introduction to OLAP Technology) )〕 which is a computer-based technique of analyzing data to look for insights. The term ''cube'' here refers to a multi-dimensional dataset, which is also sometimes called a hypercube if the number of dimensions is greater than 3. == Terminology == A cube can be considered a multi-dimensional generalization of a two- or three-dimensional spreadsheet. For example, a company might wish to summarize financial data by product, by time-period, and by city to compare actual and budget expenses. Product, time, city and scenario (actual and budget) are the data's dimensions. ''Cube'' is a shortcut for ''multidimensional dataset'', given that data can have an arbitrary number of ''dimensions''. The term hypercube is sometimes used, especially for data with more than three dimensions. ''Slicer'' is a term for a dimension which is held constant for all cells so that multidimensional information can be shown in a two dimensional physical space of a spreadsheet or pivot table. Each cell of the cube holds a number that represents some ''measure'' of the business, such as sales, profits, expenses, budget and forecast. OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「OLAP cube」の詳細全文を読む スポンサード リンク
|